﻿CREATE TABLE [dbo].[Job] (
    [JobId]          UNIQUEIDENTIFIER NOT NULL,
    [JobTitle]       NVARCHAR (300)   NOT NULL,
    [JobDescription] NTEXT            NULL,
    [JobRequirement] NTEXT            NULL,
    [EmployerId]     UNIQUEIDENTIFIER NULL,
    CONSTRAINT [PK_Job] PRIMARY KEY CLUSTERED ([JobId] ASC),
    CONSTRAINT [FK_Job_Employer] FOREIGN KEY ([EmployerId]) REFERENCES [dbo].[Employer] ([EmployerId])
);





